UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vrwuH/m7dknxfoAoA0OZZOMealQu8SiRmjFS9k6vCHc='
WHERE
key_id = 'd7842454b0e57cfc7a166f06abeb4a030dfecaced714701a5ba19f6c99c6a3a7'
AND (
token = 'vrwuH/m7dknxfoAoA0OZZOMealQu8SiRmjFS9k6vCHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)