SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '479d29356006bcefcc51f87a49b20b1fb88a406e97a12570748425e17a3ff974' 
  AND token = 'G5VxJ543OG+xWfD4MRiiFduJhKJMDeY1dcsgRuo70Eo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00072

JSON explain

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