UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CxmnHuY3uO4Sgk/bnQ5BDuEJjWZoTIyPjniagf4sqAs=' 
WHERE 
  key_id = 'b35e90cfafcd2adfdf13450d2a6678ba952b7bc6fb23d037442522d610cb35e0' 
  AND (
    token = 'CxmnHuY3uO4Sgk/bnQ5BDuEJjWZoTIyPjniagf4sqAs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033