UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qaFlnG9r6D477nBQ1t1ONxXqQboF4oRh8bFFzvBpE3I='
WHERE
key_id = '9fe84877487802f7a21ecf9e2e3d1ff7fdb8b5803d9038c82c8ea732a57be10f'
AND (
token = 'qaFlnG9r6D477nBQ1t1ONxXqQboF4oRh8bFFzvBpE3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)