UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OgQj5E5vOd2BCy3yKwkYYq5ZBO5SOkqq8EKrENSjCHo='
WHERE
key_id = 'a2cf1f4287352828c0ae60492f98c1a80d19fd1fa8b4f09be6efec982f1d8b27'
AND (
token = 'OgQj5E5vOd2BCy3yKwkYYq5ZBO5SOkqq8EKrENSjCHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)