UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xz9HfvtPfLq4KRnY82WEX+SjoG+p4ZRiok1/1007tS4='
WHERE
key_id = '36409ac4455c415ca2304d64019687d29d5e4047a887959bd1818c2dc79316a2'
AND (
token = 'xz9HfvtPfLq4KRnY82WEX+SjoG+p4ZRiok1/1007tS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)