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

Query time 0.00032