UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xYY0mi7dgyBHDs7GxoTOfZuAX3AK0Luus4H//nZwvcM='
WHERE
key_id = '2c3be5a8815ee0002d21ff3c250a799bb00de503f0d040b1a8d217e4d8aa09a8'
AND (
token = 'xYY0mi7dgyBHDs7GxoTOfZuAX3AK0Luus4H//nZwvcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)