SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '72ed1a7bda889c2bcd864a181c79d2111375e59e69789a1747f023bab42a08f6' 
  AND token = '5VyVWV+ee5gTFho46cMTsNzFFmBa9Qt5vRs5FGDmwu4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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