UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'apbPUe5o6SOlYViw2Agp1aBwXcdlpUed0uYL7cE2UVg=' 
WHERE 
  key_id = '25af23443e2aeca1c3f34ca92203da2b7bcd83c6010df83258d923f509ee67fe' 
  AND (
    token = 'apbPUe5o6SOlYViw2Agp1aBwXcdlpUed0uYL7cE2UVg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047