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