SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '305d8c81395170a7e212188b2a098270df201a0593c05a7d15a75c52e5018b47' 
  AND token = 'o9wPDBVjzUvjMxiFnvWH3aF+Kr5+MbQOcW0m+uuV1r0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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