UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5AQ9NdvfLrLJcFadX/czzTF9j7LiykT7XJZ0chxwxr0='
WHERE
key_id = 'ba8c0c62dacfb2c9a8bc96dc896074055cc586b063382830733c18639a12c745'
AND (
token = '5AQ9NdvfLrLJcFadX/czzTF9j7LiykT7XJZ0chxwxr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)