UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hNSd8tOmkqK5EEMk8J99ujfmxBEH5CQCaE39NJJ6/cA='
WHERE
key_id = '76bef3fe371598e906592ddbea2dd47aff6ad41d95199d49341b367c6a6a1a6e'
AND (
token = 'hNSd8tOmkqK5EEMk8J99ujfmxBEH5CQCaE39NJJ6/cA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)