SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = 'c73ab8ac365bf6aef3a50dd2f0b6d050961c4c71308a7b97da0c316381061714' 
  AND token = 'Y2Zxs9bxUkORdww9VMXXL6GpZ8z94kpWEHwIQpGSQ+I=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00040

JSON explain

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