UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DQ+53ylnY359igANf0xWmepJ83f0xdrDSUO88E+SO68='
WHERE
key_id = 'a1d8d290959f0b6cdcd8b2b859ecf3e0ef9e137fc1255857e20e5a8eed9f807f'
AND (
token = 'DQ+53ylnY359igANf0xWmepJ83f0xdrDSUO88E+SO68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)