SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '270ae23c214da5ab98a5b8e89a4c87ae34490d31a438c03d4d9bc7734714fedd' 
  AND token = 'dv622NteuL2pMqlETcZdhXSD1Eko5T2wK2NS8stJL24=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}