UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8gS8IwHtEA4HKhuzkHEgCMNxP5b6wC8mAd2L8GTPqFw='
WHERE
key_id = '5b7f4addf6a690f18e2f0ec7608c085aea87450b427667fa644869faa1c67115'
AND (
token = '8gS8IwHtEA4HKhuzkHEgCMNxP5b6wC8mAd2L8GTPqFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)