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