UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXH6Ofa272BCNwqtdUdq2ENF51L/K0AEEtSShR96LGY='
WHERE
key_id = 'bc8ca63992fc1d5243da6ade278d087e6994112e1aaace707c0da80f727f3e83'
AND (
token = 'gXH6Ofa272BCNwqtdUdq2ENF51L/K0AEEtSShR96LGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)