SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '7accb34f1d689c9c0bf6b75a16ff6308043ccd91e6715c0c27e9580b78f14b20' 
  AND token = '8awNbJO2n4I4R54cKfk6V1O4TOkRfZssTytfbT9R0Zc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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