UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'e3IjxGVKx85tVkMSdO6+ahRXwZUrI1NBuX42w0n9fJ0=' 
WHERE 
  key_id = 'a17d509c37cc449d4859c2032e8563c1cffe1f5837c04e5f0bcad5483435b390' 
  AND (
    token = 'e3IjxGVKx85tVkMSdO6+ahRXwZUrI1NBuX42w0n9fJ0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033