UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E1urxgOUDvuowaQrCad0oJjsUw/60Z9ACeWKEmEJTSA='
WHERE
key_id = 'f9788db17f450c02063d84fc85e4f737e196c574b64d15510388341fbdb16a3f'
AND (
token = 'E1urxgOUDvuowaQrCad0oJjsUw/60Z9ACeWKEmEJTSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)