UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+scryv6h2o2EdzYKLHvs/gqM8kEyRI26aaOz6/xlpBk='
WHERE
key_id = 'cc796b897b3f10d195c72ea50a8136b1fd05af2e441351f4c99df26785ed1817'
AND (
token = '+scryv6h2o2EdzYKLHvs/gqM8kEyRI26aaOz6/xlpBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)