UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vMKaJIcE12I7MWVAr18KXBUofRmhYN2sTUhB+X8Eao='
WHERE
key_id = 'e08325c1f146d906c93132ca809c403a6d129dff73d806a51c08e9689c0022a6'
AND (
token = '6vMKaJIcE12I7MWVAr18KXBUofRmhYN2sTUhB+X8Eao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)