UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nL/tNU0APN9c6gL0S7LrRJDW+EW2kGQ9rUYKEcwY0YQ=' 
WHERE 
  key_id = 'ac8a72d33c7c2a0cc1df2131733d707dd374886b1cfb6b20dfb4105b2ce0401e' 
  AND (
    token = 'nL/tNU0APN9c6gL0S7LrRJDW+EW2kGQ9rUYKEcwY0YQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027