UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 300, 
  token = 'lB8M0P174x0J7xhYCG2xp65G2Iw479a9D34i0nyXp60=' 
WHERE 
  key_id = '5959eee007f6141aa6c54b47bd573c87c6ec11288f88efb1d3ee3c65eadcda7e' 
  AND (
    token = 'lB8M0P174x0J7xhYCG2xp65G2Iw479a9D34i0nyXp60=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025