UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 't27IJfq2L7uaB+MY/6+IxD9p3DsgV5pklZHXB5lNPQc=' 
WHERE 
  key_id = '72bddb3b3a18c5eb5976b50a9493a9610e0e309b903e2cf66fa32bd031e4f1f1' 
  AND (
    token = 't27IJfq2L7uaB+MY/6+IxD9p3DsgV5pklZHXB5lNPQc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029