UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uIVUz8I33b1HA7XnLeEL6cQ9djAImZKP3dTGdETJNWE='
WHERE
key_id = 'b192a37cffc6dce2a131e5333942749bfb4717a04aa983046a86783dc32c6cd8'
AND (
token = 'uIVUz8I33b1HA7XnLeEL6cQ9djAImZKP3dTGdETJNWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)