UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HeIfOpuePUCBPOaIUxnT7zh8tn/7io+7ieNBA6CCBkM='
WHERE
key_id = '9501f4a77afafaa26e5c2ba1dad6479fdf685579d91875953465a7b6dcfc842a'
AND (
token = 'HeIfOpuePUCBPOaIUxnT7zh8tn/7io+7ieNBA6CCBkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)