UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'chIWtiwyQcB5wEHD/WbNvWG8UMI8mSWo/guqTOR0oHE='
WHERE
key_id = 'c4d2fa6710de4c4d8ac6d4aa31ef9b61027955c640ec65bd47a892a6b1f98804'
AND (
token = 'chIWtiwyQcB5wEHD/WbNvWG8UMI8mSWo/guqTOR0oHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)