UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZ9IX6Zl5THpvNcIBj8uSKd4WTuL/t7NJ270qbQX++w='
WHERE
key_id = 'ec82b68bd029addf652268b098f7290b7b8766e1b5963c40f09daeb751d46468'
AND (
token = 'JZ9IX6Zl5THpvNcIBj8uSKd4WTuL/t7NJ270qbQX++w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)