UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xSGnq3EvSX6bGbjALM4CM+ps5Q5pX5OBVYky8IaSok='
WHERE
key_id = 'd606a34e8895e0945367541a1ac32c85895435d6a2ef8aad3be6d19b5c10bb34'
AND (
token = '8xSGnq3EvSX6bGbjALM4CM+ps5Q5pX5OBVYky8IaSok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)