UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1vyXYwgsfoF+tzkTSwwofz38brg+UH72vmgh7h9n6mE='
WHERE
key_id = 'c1ff7e3f010d7e488bd6a872e6357a76f0e70147287102ae7ba0634f69cef239'
AND (
token = '1vyXYwgsfoF+tzkTSwwofz38brg+UH72vmgh7h9n6mE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)