UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XSJ69RIigIAz+BENplqrosmd/POt0bqye6vzpE0rJl8='
WHERE
key_id = 'd2205493b9bcdc6a6484742e73dc5378a63e910523ac28c6eedfaeeb49505200'
AND (
token = 'XSJ69RIigIAz+BENplqrosmd/POt0bqye6vzpE0rJl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)