UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yUS767odn7W+9f0fO5np6THkfODMgnwpyfHYxShrWhc='
WHERE
key_id = '6d6e636dada40b3ce3ec0b73520e9c841d57c2d66bbf20c0ba7096b7d4135f1a'
AND (
token = 'yUS767odn7W+9f0fO5np6THkfODMgnwpyfHYxShrWhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)