UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C0AOH689A+93dCfLGrlg8PKR/izJh2BCzko9jpop9T8='
WHERE
key_id = 'ffd6a7b263de5f4b249af39f37905ebe2cb1650b4b73062e02943acdda5d40f7'
AND (
token = 'C0AOH689A+93dCfLGrlg8PKR/izJh2BCzko9jpop9T8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)