UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vOYV/VO/shf5qh5tE89RHaFg0RFJbKezkNZMdowpb8w='
WHERE
key_id = 'a7e022a6b6ac5c511e6839581f37907ced972bd2568a73f286e997ee2f0f3af6'
AND (
token = 'vOYV/VO/shf5qh5tE89RHaFg0RFJbKezkNZMdowpb8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)