UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cQYbT0KegG9ynjBmYjBZhREh0rQtUg3E11SoQzD2SrA='
WHERE
key_id = '49ef705889e74213c55d0c241681747d64d084d48b3d4681185d126ee1087123'
AND (
token = 'cQYbT0KegG9ynjBmYjBZhREh0rQtUg3E11SoQzD2SrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)