UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNAqOvYSBPxAagt0sU7pos36ttkYSE9HCOdnjmYGkrw='
WHERE
key_id = '720eeea987b53a1fd66e363fa44fbf4cad5b5d7b55461a8ebbde1e3dbc9db4bc'
AND (
token = 'XNAqOvYSBPxAagt0sU7pos36ttkYSE9HCOdnjmYGkrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)