UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lLp0gq+NRJOt/ss09bFLKfpLxAqoBNSCiKIOEftAMQ4='
WHERE
key_id = '23e6402114e786dba6d2498fb6905d6177200ad7313cd9cbd0d4268fcf3f97c5'
AND (
token = 'lLp0gq+NRJOt/ss09bFLKfpLxAqoBNSCiKIOEftAMQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)