UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QHUpDpPNQWi8VnR+/w1HYCH4QcRGGGJgLZJvCYCjhC8='
WHERE
key_id = '23db1c7e657c97a71113027cb50853df191e3abd22f2cc90a52debeeeb8c947a'
AND (
token = 'QHUpDpPNQWi8VnR+/w1HYCH4QcRGGGJgLZJvCYCjhC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)