UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kMMQ65xO0mx+b+2+ljtZxd/RC2I9Ni2bWJWCLqNoaYE=' 
WHERE 
  key_id = '3e94106231f83b435826af3c9dc30cde719a0f8a0a7884b74db678a1cb7cea03' 
  AND (
    token = 'kMMQ65xO0mx+b+2+ljtZxd/RC2I9Ni2bWJWCLqNoaYE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047