UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jng7jXyY1QNpTkrrMoYnuYiWWOPU+BP4iIFIMOscq/o='
WHERE
key_id = '5b1b22fa9f5042043c302ec2ace5e5914a71976d464e95f6f2c330a0c78732e0'
AND (
token = 'Jng7jXyY1QNpTkrrMoYnuYiWWOPU+BP4iIFIMOscq/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)