UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8xPAaN9g1+ggw46a4MXCRbx0yiNzgekZ2mpj1ttquv4=' 
WHERE 
  key_id = '72d1282f8aa4aada1d48ec766ba71e5c5a02b6756d59fb3dab4a7141ba00f4da' 
  AND (
    token = '8xPAaN9g1+ggw46a4MXCRbx0yiNzgekZ2mpj1ttquv4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034