UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '40vZe9YpCYuO1RIMTYqX74zCY7DZKoo5mGJhsOKB7pE=' 
WHERE 
  key_id = '07aae2639bec6c4162c7d1ec7864cacbb22bdd6039ee6e9126936e7401622846' 
  AND (
    token = '40vZe9YpCYuO1RIMTYqX74zCY7DZKoo5mGJhsOKB7pE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052