UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'US6Rc6l7dLZKAOPJ3cWXO8wmjnkFil9NomqSDN2R3K0='
WHERE
key_id = '31d15528b608c7ba22d038958c4f90a99b1b62e6e4b35a64619704cd7e0abcf8'
AND (
token = 'US6Rc6l7dLZKAOPJ3cWXO8wmjnkFil9NomqSDN2R3K0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)