UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4Kj+9OFmtZafiSudSTOPapqrvkKgnUsDd8vjLz1eHMM=' 
WHERE 
  key_id = 'aa109d183c5b207ab2bedf40d459298f8f74245350f6bf83d11f7c12dfbb015b' 
  AND (
    token = '4Kj+9OFmtZafiSudSTOPapqrvkKgnUsDd8vjLz1eHMM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024