UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1i9yCksjKvKPAaAkL2tqBY+ibu9/d/az1198n0NmRqQ=' 
WHERE 
  key_id = '2c05105783f5540c4fa962453c1e46a533c657cc140f38de44ddad047f1def51' 
  AND (
    token = '1i9yCksjKvKPAaAkL2tqBY+ibu9/d/az1198n0NmRqQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035