SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e33a67ffb84ec38e8a69c03b69473f012e9f2ac111da14f50f66cc1550e4c958' 
  AND token = 'J+mNT0sdYubK6PRJflVetDFi7sGnOvX62GSSb7X4Xwk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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