UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'isoLOpKKTxHYqBCAKVQMRg88/7AJmGPaluoy/icAUCE='
WHERE
key_id = '0bf313b8c76e5f89f68a401a4d0357c78e81e292935e4bcb5f4e65aa96334665'
AND (
token = 'isoLOpKKTxHYqBCAKVQMRg88/7AJmGPaluoy/icAUCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)