UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ApRO3s1YGKNxOVttYbahK+A+ezGwW9jZ80kXttc9ZF4='
WHERE
key_id = '7ccaefbe1e41cb58ca62dd27e4d5ca250575388da8564333c09eb6de6cec250f'
AND (
token = 'ApRO3s1YGKNxOVttYbahK+A+ezGwW9jZ80kXttc9ZF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)