SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8fb3d8d165ad32cf6722defba324ddbaf5e13177d4d0f6a9fb62a34f76ebafea' 
  AND token = 'p1Q1hl5PNBVEtOoyo1KulCKN4dt2TLuFlUxoPDTDsN0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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