UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ciMMK0JEwreFpp+jwQ8PxvhO67wXqHeb8r2s6Ck4s00='
WHERE
key_id = '2ca6a15dc8baca7ebaec83c5f20caf36c0cef3aac5fa396afff15fef3daa91cb'
AND (
token = 'ciMMK0JEwreFpp+jwQ8PxvhO67wXqHeb8r2s6Ck4s00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)