UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EG5T84xopKCjbAt6AiW9LCJNGxmSIUqYqoz/2VTICbw='
WHERE
key_id = '030b1ae9e10f3158d80beb68219dea2718b52d82835c4526e7f0a2dc60e28c3e'
AND (
token = 'EG5T84xopKCjbAt6AiW9LCJNGxmSIUqYqoz/2VTICbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)