UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cgl9jYZr6YufuaSg8UmQtLiqQnap7jLKT6hHSipB7hE='
WHERE
key_id = 'ab0cc51f7501fc6173c3d2324e91a29e5c87f12d8411b690e02f1862f096a8e8'
AND (
token = 'Cgl9jYZr6YufuaSg8UmQtLiqQnap7jLKT6hHSipB7hE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)